/*
Navicat MySQL Data Transfer

Source Server         : sdfsf
Source Server Version : 50632
Source Host           : localhost:3306
Source Database       : bingo

Target Server Type    : MYSQL
Target Server Version : 50632
File Encoding         : 65001

Date: 2016-09-26 22:39:43
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for area
-- ----------------------------
DROP TABLE IF EXISTS `area`;
CREATE TABLE `area` (
  `Code` int(15) NOT NULL AUTO_INCREMENT,
  `Name` varchar(100) DEFAULT NULL,
  `Fun` varchar(100) DEFAULT NULL,
  `Parent` int(15) DEFAULT NULL,
  PRIMARY KEY (`Code`)
) ENGINE=InnoDB AUTO_INCREMENT=300021 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of area
-- ----------------------------
INSERT INTO `area` VALUES ('100000', '中国', 'Country', null);
INSERT INTO `area` VALUES ('200000', '广东省', 'Province', '100000');
INSERT INTO `area` VALUES ('300000', '广州市', 'City', '200000');
INSERT INTO `area` VALUES ('300001', '汕头市', 'City', '200000');
INSERT INTO `area` VALUES ('300002', '湛江市', 'City', '200000');
INSERT INTO `area` VALUES ('300003', '潮州市', 'City', '200000');
INSERT INTO `area` VALUES ('300004', '茂名市', 'City', '200000');
INSERT INTO `area` VALUES ('300005', '深圳市', 'City', '200000');
INSERT INTO `area` VALUES ('300006', '韶关市', 'City', '200000');
INSERT INTO `area` VALUES ('300007', '梅州市', 'City', '200000');
INSERT INTO `area` VALUES ('300008', '惠州市', 'City', '200000');
INSERT INTO `area` VALUES ('300009', '东莞市', 'City', '200000');
INSERT INTO `area` VALUES ('300010', '江门市', 'City', '200000');
INSERT INTO `area` VALUES ('300011', '佛山市', 'City', '200000');
INSERT INTO `area` VALUES ('300012', '肇庆市', 'City', '200000');
INSERT INTO `area` VALUES ('300013', '珠海市', 'City', '200000');
INSERT INTO `area` VALUES ('300014', '中山市', 'City', '200000');
INSERT INTO `area` VALUES ('300015', '河源市', 'City', '200000');
INSERT INTO `area` VALUES ('300016', '汕尾市', 'City', '200000');
INSERT INTO `area` VALUES ('300017', '阳江市', 'City', '200000');
INSERT INTO `area` VALUES ('300018', '清远市', 'City', '200000');
INSERT INTO `area` VALUES ('300019', '揭阳市', 'City', '200000');
INSERT INTO `area` VALUES ('300020', '云浮市', 'City', '200000');

-- ----------------------------
-- Table structure for association
-- ----------------------------
DROP TABLE IF EXISTS `association`;
CREATE TABLE `association` (
  `AssociationNO` int(10) NOT NULL AUTO_INCREMENT,
  `Name` varchar(100) DEFAULT NULL,
  `SchoolNO` int(10) DEFAULT NULL,
  `AssociationGrade` varchar(10) DEFAULT NULL,
  `ScaleNO` int(15) DEFAULT NULL,
  `Status` varchar(60) DEFAULT NULL,
  `Remark` varchar(255) DEFAULT NULL,
  `NatureNO` int(15) DEFAULT NULL,
  `TypeNO` int(15) DEFAULT NULL,
  `TypeDetailNO` int(15) DEFAULT NULL,
  `SchoolTypeNO` varchar(100) DEFAULT NULL,
  `SelfPassword` varchar(100) DEFAULT NULL,
  `UserPassword` varchar(100) DEFAULT NULL,
  `CreateUserNO` int(15) DEFAULT NULL,
  `UpdateTime` datetime DEFAULT NULL,
  `CreateTime` datetime DEFAULT NULL,
  `DeptAmount` int(11) DEFAULT NULL,
  PRIMARY KEY (`AssociationNO`),
  KEY `FKAssociatio856502` (`SchoolNO`),
  CONSTRAINT `school` FOREIGN KEY (`SchoolNO`) REFERENCES `school` (`SchoolNO`)
) ENGINE=InnoDB AUTO_INCREMENT=400000006 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of association
-- ----------------------------

-- ----------------------------
-- Table structure for basedata
-- ----------------------------
DROP TABLE IF EXISTS `basedata`;
CREATE TABLE `basedata` (
  `RuleNO` int(10) NOT NULL AUTO_INCREMENT,
  `Fun` varchar(30) DEFAULT NULL,
  `Status` varchar(60) DEFAULT NULL,
  `ValueFrom` varchar(60) DEFAULT NULL,
  `ValueTo` varchar(60) DEFAULT NULL,
  `Level` varchar(120) DEFAULT NULL,
  `Version` int(10) DEFAULT NULL,
  `Description` varchar(255) DEFAULT NULL,
  `ParentNo` int(10) DEFAULT NULL,
  `DisplayOrder` int(4) DEFAULT NULL,
  PRIMARY KEY (`RuleNO`)
) ENGINE=InnoDB AUTO_INCREMENT=900000171 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of basedata
-- ----------------------------
INSERT INTO `basedata` VALUES ('900000001', 'Nature', 'Active', '', '', '校级', null, '校级', null, null);
INSERT INTO `basedata` VALUES ('900000002', 'Nature', 'Active', '', '', '院级', null, '院级', null, null);
INSERT INTO `basedata` VALUES ('900000003', 'StudentInterval', 'Active', '0', '100', '1-100', null, '1-100', null, null);
INSERT INTO `basedata` VALUES ('900000004', 'StudentInterval', 'Active', '101', '300', '101-300', null, '101-300', null, null);
INSERT INTO `basedata` VALUES ('900000005', 'StudentInterval', 'Active', '301', '500', '301-500', null, '301-500', null, null);
INSERT INTO `basedata` VALUES ('900000006', 'StudentInterval', 'Active', '501', '1000', '501-1000', null, '501-1000', null, null);
INSERT INTO `basedata` VALUES ('900000007', 'StudentInterval', 'Active', '1001', '1500', '1001-1500', null, '1001-1500', null, null);
INSERT INTO `basedata` VALUES ('900000008', 'StudentInterval', 'Active', '1501', '2500', '1501-2500', null, '1501-2500', null, null);
INSERT INTO `basedata` VALUES ('900000009', 'StudentInterval', 'Active', '2501', '3000', '2501-3000', null, '2501-3000', null, null);
INSERT INTO `basedata` VALUES ('900000010', 'StudentInterval', 'Active', '3000', '3000000000', '3000以上', null, '3000以上', null, null);
INSERT INTO `basedata` VALUES ('900000011', 'SponsorMoney', 'Active', '500', '2500', '500-2500', null, '500-2500', null, null);
INSERT INTO `basedata` VALUES ('900000012', 'SponsorMoney', 'Active', '2501', '5000', '2501-5000', null, '2501-5000', null, null);
INSERT INTO `basedata` VALUES ('900000013', 'SponsorMoney', 'Active', '5001', '7500', '5001-7500', null, '5001-7500', null, null);
INSERT INTO `basedata` VALUES ('900000014', 'SponsorMoney', 'Active', '7501', '10000', '7501-10000', null, '7501-10000', null, null);
INSERT INTO `basedata` VALUES ('900000015', 'SponsorMoney', 'Active', '10001', '15000', '10001-15000', null, '10001-15000', null, null);
INSERT INTO `basedata` VALUES ('900000016', 'SponsorMoney', 'Active', '15001', '20000', '15001-20000', null, '15001-20000', null, null);
INSERT INTO `basedata` VALUES ('900000017', 'SponsorMoney', 'Active', '20001', '25000', '20001-25000', null, '20001-25000', null, null);
INSERT INTO `basedata` VALUES ('900000018', 'SponsorMoney', 'Active', '25001', '30000', '25001-30000', null, '25001-30000', null, null);
INSERT INTO `basedata` VALUES ('900000019', 'SponsorMoney', 'Active', '30001', '50000', '30001-50000', null, '30001-50000', null, null);
INSERT INTO `basedata` VALUES ('900000020', 'SponsorMoney', 'Active', '50001', '70000', '50001-70000', null, '50001-70000', null, null);
INSERT INTO `basedata` VALUES ('900000021', 'SponsorMoney', 'Active', '70001', '100000', '70001-100000', null, '70001-100000', null, null);
INSERT INTO `basedata` VALUES ('900000022', 'SponsorMoney', 'Active', '100001', '150000', '100001-150000', null, '100001-150000', null, null);
INSERT INTO `basedata` VALUES ('900000023', 'SponsorMoney', 'Active', '150001', '200000', '150001-200000', null, '150001-200000', null, null);
INSERT INTO `basedata` VALUES ('900000024', 'SponsorMoney', 'Active', '200000', '200000000', '200000以上', null, '200000以上', null, null);
INSERT INTO `basedata` VALUES ('900000025', 'StudentLevel', 'Active', '', '', '官方代理社团', null, '官方代理社团', null, null);
INSERT INTO `basedata` VALUES ('900000026', 'StudentLevel', 'Active', '500', '5000000', '金牌社团', null, '金牌社团', null, null);
INSERT INTO `basedata` VALUES ('900000027', 'StudentLevel', 'Active', '400', '500', '银牌社团', null, '银牌社团', null, null);
INSERT INTO `basedata` VALUES ('900000028', 'StudentLevel', 'Active', '300', '400', '铜牌社团', null, '铜牌社团', null, null);
INSERT INTO `basedata` VALUES ('900000029', 'StudentLevel', 'Active', '200', '300', '普通社团V3', null, '普通社团V3', null, null);
INSERT INTO `basedata` VALUES ('900000030', 'StudentLevel', 'Active', '100', '200', '普通社团V2', null, '普通社团V2', null, null);
INSERT INTO `basedata` VALUES ('900000031', 'StudentLevel', 'Active', '0', '100', '普通社团V1', null, '普通社团V1', null, null);
INSERT INTO `basedata` VALUES ('900000032', 'SponsorMoney', 'Active', '', '', '2000', null, '2000', null, null);
INSERT INTO `basedata` VALUES ('900000033', 'SponsorMultiple', 'Active', '', '', '5', null, '5', null, null);
INSERT INTO `basedata` VALUES ('900000034', 'CancelRemark', 'Active', '', '', '活动信息错误', null, '活动信息错误', null, null);
INSERT INTO `basedata` VALUES ('900000035', 'CancelRemark', 'Active', '', '', '活动长时间没收到邀请', null, '活动长时间没收到邀请', null, null);
INSERT INTO `basedata` VALUES ('900000036', 'CancelRemark', 'Active', '', '', '活动需要重新发布', null, '活动需要重新发布', null, null);
INSERT INTO `basedata` VALUES ('900000037', 'CancelRemark', 'Active', '', '', '活动已达成目的', null, '活动已达成目的', null, null);
INSERT INTO `basedata` VALUES ('900000038', 'CancelRemark', 'Active', '', '', '活动时间过期', null, '活动时间过期', null, null);
INSERT INTO `basedata` VALUES ('900000039', 'CancelRemark', 'Active', '', '', '用户自主下架', null, '用户自主下架', null, null);
INSERT INTO `basedata` VALUES ('900000040', 'ActivityType', 'Active', '', '', '招新类', null, '招新类', null, null);
INSERT INTO `basedata` VALUES ('900000041', 'ActivityType', 'Active', '', '', '文艺类', null, '文艺类', null, null);
INSERT INTO `basedata` VALUES ('900000042', 'ActivityType', 'Active', '', '', '表演类', null, '表演类', null, null);
INSERT INTO `basedata` VALUES ('900000043', 'ActivityType', 'Active', '', '', '晚会类 ', null, '晚会类 ', null, null);
INSERT INTO `basedata` VALUES ('900000044', 'ActivityType', 'Active', '', '', '体育类', null, '体育类', null, null);
INSERT INTO `basedata` VALUES ('900000045', 'ActivityType', 'Active', '', '', '讲座类', null, '讲座类', null, null);
INSERT INTO `basedata` VALUES ('900000046', 'ActivityType', 'Active', '', '', '比赛类', null, '比赛类', null, null);
INSERT INTO `basedata` VALUES ('900000047', 'ActivityType', 'Active', '', '', '其它', null, '其它', null, null);
INSERT INTO `basedata` VALUES ('900000048', 'AssosiationType', 'Active', '', '', '组织类-学生会', null, '组织类-学生会', null, null);
INSERT INTO `basedata` VALUES ('900000049', 'AssosiationType', 'Active', '', '', '组织类-团委', null, '组织类-团委', null, null);
INSERT INTO `basedata` VALUES ('900000050', 'AssosiationType', 'Active', '', '', '组织类-社团联合会', null, '组织类-社团联合会', null, null);
INSERT INTO `basedata` VALUES ('900000051', 'AssosiationType', 'Active', '', '', '组织类-其他', null, '组织类-其他', null, null);
INSERT INTO `basedata` VALUES ('900000052', 'AssosiationType', 'Active', '', '', '社团类-青年志愿者服务队', null, '社团类-青年志愿者服务队', null, null);
INSERT INTO `basedata` VALUES ('900000053', 'AssosiationType', 'Active', '', '', '社团类-红十字会', null, '社团类-红十字会', null, null);
INSERT INTO `basedata` VALUES ('900000054', 'AssosiationType', 'Active', '', '', '社团类-体育类社团', null, '社团类-体育类社团', null, null);
INSERT INTO `basedata` VALUES ('900000055', 'AssosiationType', 'Active', '', '', '社团类-棋牌类社团', null, '社团类-棋牌类社团', null, null);
INSERT INTO `basedata` VALUES ('900000056', 'AssosiationType', 'Active', '', '', '社团类-动漫社', null, '社团类-动漫社', null, null);
INSERT INTO `basedata` VALUES ('900000057', 'AssosiationType', 'Active', '', '', '社团类-文娱类社团', null, '社团类-文娱类社团', null, null);
INSERT INTO `basedata` VALUES ('900000058', 'AssosiationType', 'Active', '', '', '社团类-兴趣类社团', null, '社团类-兴趣类社团', null, null);
INSERT INTO `basedata` VALUES ('900000059', 'AssosiationType', 'Active', '', '', '社团类-其他社团', null, '社团类-其他社团', null, null);
INSERT INTO `basedata` VALUES ('900000060', 'CompanyMaterial', 'Active', '', '', '公司产品', null, '公司产品', null, null);
INSERT INTO `basedata` VALUES ('900000061', 'CompanyMaterial', 'Active', '', '', '传单 ', null, '传单 ', null, null);
INSERT INTO `basedata` VALUES ('900000062', 'CompanyMaterial', 'Active', '', '', '音箱', null, '音箱', null, null);
INSERT INTO `basedata` VALUES ('900000063', 'CompanyMaterial', 'Active', '', '', '横幅', null, '横幅', null, null);
INSERT INTO `basedata` VALUES ('900000064', 'CompanyMaterial', 'Active', '', '', '帐篷', null, '帐篷', null, null);
INSERT INTO `basedata` VALUES ('900000065', 'CompanyMaterial', 'Active', '', '', '桌椅', null, '桌椅', null, null);
INSERT INTO `basedata` VALUES ('900000066', 'CompanyMaterial', 'Active', '', '', '活动展架', null, '活动展架', null, null);
INSERT INTO `basedata` VALUES ('900000067', 'CompanyMaterial', 'Active', '', '', '活动海报', null, '活动海报', null, null);
INSERT INTO `basedata` VALUES ('900000068', 'CompanyMaterial', 'Active', '', '', '其他', null, '其他', null, null);
INSERT INTO `basedata` VALUES ('900000069', 'AssociationMaterial', 'Active', '', '', '横幅', null, '横幅', null, null);
INSERT INTO `basedata` VALUES ('900000070', 'AssociationMaterial', 'Active', '', '', '传单(黑白，彩色)', null, '传单(黑白，彩色)', null, null);
INSERT INTO `basedata` VALUES ('900000071', 'AssociationMaterial', 'Active', '', '', 'KT板', null, 'KT板', null, null);
INSERT INTO `basedata` VALUES ('900000072', 'AssociationMaterial', 'Active', '', '', '幕布', null, '幕布', null, null);
INSERT INTO `basedata` VALUES ('900000073', 'AssociationMaterial', 'Active', '', '', '易拉宝', null, '易拉宝', null, null);
INSERT INTO `basedata` VALUES ('900000074', 'AssociationMaterial', 'Active', '', '', '推头', null, '推头', null, null);
INSERT INTO `basedata` VALUES ('900000075', 'AssociationMaterial', 'Active', '', '', '灯布', null, '灯布', null, null);
INSERT INTO `basedata` VALUES ('900000076', 'AssociationMaterial', 'Active', '', '', '木构', null, '木构', null, null);
INSERT INTO `basedata` VALUES ('900000077', 'AssociationMaterial', 'Active', '', '', '展位', null, '展位', null, null);
INSERT INTO `basedata` VALUES ('900000078', 'AssociationMaterial', 'Active', '', '', '灯箱', null, '灯箱', null, null);
INSERT INTO `basedata` VALUES ('900000079', 'AssociationMaterial', 'Active', '', '', '桁架', null, '桁架', null, null);
INSERT INTO `basedata` VALUES ('900000080', 'AssociationMaterial', 'Active', '', '', '麦克风(耳麦，手麦，麦架)', null, '麦克风(耳麦，手麦，麦架)', null, null);
INSERT INTO `basedata` VALUES ('900000081', 'AssociationMaterial', 'Active', '', '', '帐篷', null, '帐篷', null, null);
INSERT INTO `basedata` VALUES ('900000082', 'AssociationMaterial', 'Active', '', '', '桌椅', null, '桌椅', null, null);
INSERT INTO `basedata` VALUES ('900000083', 'AssociationMaterial', 'Active', '', '', '音箱', null, '音箱', null, null);
INSERT INTO `basedata` VALUES ('900000084', 'AssociationMaterial', 'Active', '', '', '活动展架', null, '活动展架', null, null);
INSERT INTO `basedata` VALUES ('900000085', 'AssociationMaterial', 'Active', '', '', '活动海报', null, '活动海报', null, null);
INSERT INTO `basedata` VALUES ('900000086', 'AssociationMaterial', 'Active', '', '', '其他', null, '其他', null, null);
INSERT INTO `basedata` VALUES ('900000087', 'CheckCompanyRejectedRemark', 'Active', '', '', '不存在您所输入的代理官口号令', null, '不存在您所输入的代理官口号令', null, null);
INSERT INTO `basedata` VALUES ('900000088', 'CheckCompanyRejectedRemark', 'Active', '', '', '企业全称与营业执照上的不一致', null, '企业全称与营业执照上的不一致', null, null);
INSERT INTO `basedata` VALUES ('900000089', 'CheckCompanyRejectedRemark', 'Active', '', '', '企业地址不详细', null, '企业地址不详细', null, null);
INSERT INTO `basedata` VALUES ('900000090', 'CheckCompanyRejectedRemark', 'Active', '', '', '企业网址无法正常打开或网站内容不全', null, '企业网址无法正常打开或网站内容不全', null, null);
INSERT INTO `basedata` VALUES ('900000091', 'CheckCompanyRejectedRemark', 'Active', '', '', '注册人姓名与身份证不一致', null, '注册人姓名与身份证不一致', null, null);
INSERT INTO `basedata` VALUES ('900000092', 'CheckCompanyRejectedRemark', 'Active', '', '', '未上传正确的身份证', null, '未上传正确的身份证', null, null);
INSERT INTO `basedata` VALUES ('900000093', 'CheckCompanyRejectedRemark', 'Active', '', '', '执照名称或注册号与营业执照不一致', null, '执照名称或注册号与营业执照不一致', null, null);
INSERT INTO `basedata` VALUES ('900000094', 'CheckCompanyRejectedRemark', 'Active', '', '', '未上传正确的营业执照', null, '未上传正确的营业执照', null, null);
INSERT INTO `basedata` VALUES ('900000095', 'CheckCompanyRejectedRemark', 'Active', '', '', '邮箱未验证', null, '邮箱未验证', null, null);
INSERT INTO `basedata` VALUES ('900000096', 'CheckAssociationRejectedRemark', 'Active', '', '', '所属院系不正确或不存在', null, '所属院系不正确或不存在', null, null);
INSERT INTO `basedata` VALUES ('900000097', 'CheckAssociationRejectedRemark', 'Active', '', '', '注册人姓名与身份证不一致', null, '注册人姓名与身份证不一致', null, null);
INSERT INTO `basedata` VALUES ('900000098', 'CheckAssociationRejectedRemark', 'Active', '', '', '注册人学号与学生证不一致', null, '注册人学号与学生证不一致', null, null);
INSERT INTO `basedata` VALUES ('900000099', 'CheckAssociationRejectedRemark', 'Active', '', '', '邮箱未验证', null, '邮箱未验证', null, null);
INSERT INTO `basedata` VALUES ('900000100', 'CheckAssociationRejectedRemark', 'Active', '', '', '未上传正确的身份证', null, '未上传正确的身份证', null, null);
INSERT INTO `basedata` VALUES ('900000101', 'CheckAssociationRejectedRemark', 'Active', '', '', '未上传正确的学生证', null, '未上传正确的学生证', null, null);
INSERT INTO `basedata` VALUES ('900000102', 'AssociationSize', 'Active', '1', '10', '1-10人', null, '1-10人', null, null);
INSERT INTO `basedata` VALUES ('900000103', 'AssociationSize', 'Active', '11', '30', '11-30人', null, '11-30人', null, null);
INSERT INTO `basedata` VALUES ('900000104', 'AssociationSize', 'Active', '31', '60', '31-60人', null, '31-60人', null, null);
INSERT INTO `basedata` VALUES ('900000105', 'AssociationSize', 'Active', '61', '90', '61-90人', null, '61-90人', null, null);
INSERT INTO `basedata` VALUES ('900000106', 'AssociationSize', 'Active', '91', '120', '91-120人', null, '91-120人', null, null);
INSERT INTO `basedata` VALUES ('900000107', 'AssociationSize', 'Active', '121', '150', '121-150人', null, '121-150人', null, null);
INSERT INTO `basedata` VALUES ('900000108', 'AssociationSize', 'Active', '151', '200', '151-200人', null, '151-200人', null, null);
INSERT INTO `basedata` VALUES ('900000109', 'AssociationSize', 'Active', '201', '250', '201-250人', null, '201-250人', null, null);
INSERT INTO `basedata` VALUES ('900000110', 'AssociationSize', 'Active', '251', '300', '251-300人', null, '251-300人', null, null);
INSERT INTO `basedata` VALUES ('900000111', 'AssociationSize', 'Active', '300', '1000000', '300以上', null, '300以上', null, null);
INSERT INTO `basedata` VALUES ('900000112', 'AssociationSchoolType', 'Active', '', '', '组织类', null, '组织类', null, null);
INSERT INTO `basedata` VALUES ('900000113', 'AssociationSchoolType', 'Active', '', '', '社团类', null, '社团类', null, null);
INSERT INTO `basedata` VALUES ('900000114', 'AssociationRejectRemark', 'Active', '', '', '信息不匹配', null, '信息不匹配', null, null);
INSERT INTO `basedata` VALUES ('900000115', 'AssociationRejectRemark', 'Active', '', '', '企业赞助金不适合', null, '企业赞助金不适合', null, null);
INSERT INTO `basedata` VALUES ('900000116', 'AssociationRejectRemark', 'Active', '', '', '企业所在地不是所需所在地 ', null, '企业所在地不是所需所在地 ', null, null);
INSERT INTO `basedata` VALUES ('900000117', 'AssociationRejectRemark', 'Active', '', '', '已受邀于其他企业赞助', null, '已受邀于其他企业赞助', null, null);
INSERT INTO `basedata` VALUES ('900000118', 'AssociationRejectRemark', 'Active', '', '', '其他', null, '其他', null, null);
INSERT INTO `basedata` VALUES ('900000119', 'CompanyRejectRemark', 'Active', '', '', '信息不匹配', null, '信息不匹配', null, null);
INSERT INTO `basedata` VALUES ('900000120', 'CompanyRejectRemark', 'Active', '', '', '社团规模太小', null, '社团规模太小', null, null);
INSERT INTO `basedata` VALUES ('900000121', 'CompanyRejectRemark', 'Active', '', '', '社团所在地不是所需所在地 ', null, '社团所在地不是所需所在地 ', null, null);
INSERT INTO `basedata` VALUES ('900000122', 'CompanyRejectRemark', 'Active', '', '', '已受邀于其他社团活动', null, '已受邀于其他社团活动', null, null);
INSERT INTO `basedata` VALUES ('900000123', 'CompanyRejectRemark', 'Active', '', '', '其他', null, '其他', null, null);
INSERT INTO `basedata` VALUES ('900000124', 'AssociationProjectReject', 'Active', '', '', '信息不正确', null, '信息不正确', null, null);
INSERT INTO `basedata` VALUES ('900000125', 'AssociationProjectReject', 'Active', '', '', '活动名称错误', null, '活动名称错误', null, null);
INSERT INTO `basedata` VALUES ('900000126', 'AssociationProjectReject', 'Active', '', '', '活动所需金额超过限定范围', null, '活动所需金额超过限定范围', null, null);
INSERT INTO `basedata` VALUES ('900000127', 'AssociationProjectReject', 'Active', '', '', '社团活动书所属社团已达到3个合作中的合同', null, '社团活动书所属社团已达到3个合作中的合同', null, null);
INSERT INTO `basedata` VALUES ('900000128', 'CompanyProjectReject', 'Active', '', '', '信息不正确', null, '信息不正确', null, null);
INSERT INTO `basedata` VALUES ('900000129', 'CompanyProjectReject', 'Active', '', '', '活动名称错误', null, '活动名称错误', null, null);
INSERT INTO `basedata` VALUES ('900000130', 'CompanyProjectReject', 'Active', '', '', '赞助提供金额超出平台限定', null, '赞助提供金额超出平台限定', null, null);
INSERT INTO `basedata` VALUES ('900000131', 'CompanyProjectReject', 'Active', '', '', '赞助时间过长', null, '赞助时间过长', null, null);
INSERT INTO `basedata` VALUES ('900000132', 'AgentReward', 'Active', '0', '5000', '赞助金的8%', null, '赞助金的8%', null, null);
INSERT INTO `basedata` VALUES ('900000133', 'AgentReward', 'Active', '5001', '10000', '赞助金的8.5%', null, '赞助金的8.5%', null, null);
INSERT INTO `basedata` VALUES ('900000134', 'AgentReward', 'Active', '10001', '15000', '赞助金的9%', null, '赞助金的9%', null, null);
INSERT INTO `basedata` VALUES ('900000135', 'AgentReward', 'Active', '15001', '20000', '赞助金的9.5%', null, '赞助金的9.5%', null, null);
INSERT INTO `basedata` VALUES ('900000136', 'AgentReward', 'Active', '20001', '200000000', '赞助金的10%', null, '赞助金的10%', null, null);
INSERT INTO `basedata` VALUES ('900000137', 'CompanyType', 'Active', '', '', '外资独资（欧美企业）', null, '外资独资（欧美企业）', null, null);
INSERT INTO `basedata` VALUES ('900000138', 'CompanyType', 'Active', '', '', '外资独资（非欧美企业）', null, '外资独资（非欧美企业）', null, null);
INSERT INTO `basedata` VALUES ('900000139', 'CompanyType', 'Active', '', '', '合资/合作（欧美企业）', null, '合资/合作（欧美企业）', null, null);
INSERT INTO `basedata` VALUES ('900000140', 'CompanyType', 'Active', '', '', '合资/合作（非欧美企业）', null, '合资/合作（非欧美企业）', null, null);
INSERT INTO `basedata` VALUES ('900000141', 'CompanyType', 'Active', '', '', '国营企业/上市企业', null, '国营企业/上市企业', null, null);
INSERT INTO `basedata` VALUES ('900000142', 'CompanyType', 'Active', '', '', '民营/私营企业/非上市企业', null, '民营/私营企业/非上市企业', null, null);
INSERT INTO `basedata` VALUES ('900000143', 'CompanyType', 'Active', '', '', '外企代表处', null, '外企代表处', null, null);
INSERT INTO `basedata` VALUES ('900000144', 'CompanyType', 'Active', '', '', '其他', null, '其他', null, null);
INSERT INTO `basedata` VALUES ('900000145', 'CompanySize', 'Active', '0', '50', '小于50人', null, '小于50人', null, null);
INSERT INTO `basedata` VALUES ('900000146', 'CompanySize', 'Active', '50', '150', '50-150', null, '50-150', null, null);
INSERT INTO `basedata` VALUES ('900000147', 'CompanySize', 'Active', '151', '500', '151-500', null, '151-500', null, null);
INSERT INTO `basedata` VALUES ('900000148', 'CompanySize', 'Active', '501', '2000', '501-2000', null, '501-2000', null, null);
INSERT INTO `basedata` VALUES ('900000149', 'CompanySize', 'Active', '2000', '', '2000以上', null, '2000以上', null, null);
INSERT INTO `basedata` VALUES ('900000150', 'CompanyIndustry', 'Active', '', '', '家电', null, '家电', null, null);
INSERT INTO `basedata` VALUES ('900000151', 'CompanyIndustry', 'Active', '', '', '通讯', null, '通讯', null, null);
INSERT INTO `basedata` VALUES ('900000152', 'CompanyIndustry', 'Active', '', '', '房产建材', null, '房产建材', null, null);
INSERT INTO `basedata` VALUES ('900000153', 'CompanyIndustry', 'Active', '', '', '医疗保健', null, '医疗保健', null, null);
INSERT INTO `basedata` VALUES ('900000154', 'CompanyIndustry', 'Active', '', '', '工业制造', null, '工业制造', null, null);
INSERT INTO `basedata` VALUES ('900000155', 'CompanyIndustry', 'Active', '', '', '现代服务', null, '现代服务', null, null);
INSERT INTO `basedata` VALUES ('900000156', 'CompanyIndustry', 'Active', '', '', '日用消费品', null, '日用消费品', null, null);
INSERT INTO `basedata` VALUES ('900000157', 'CompanyIndustry', 'Active', '', '', '酒店餐饮', null, '酒店餐饮', null, null);
INSERT INTO `basedata` VALUES ('900000158', 'CompanyIndustry', 'Active', '', '', '食品饮料', null, '食品饮料', null, null);
INSERT INTO `basedata` VALUES ('900000159', 'CompanyIndustry', 'Active', '', '', '化妆', null, '化妆', null, null);
INSERT INTO `basedata` VALUES ('900000160', 'CompanyIndustry', 'Active', '', '', '汽车', null, '汽车', null, null);
INSERT INTO `basedata` VALUES ('900000161', 'CompanyIndustry', 'Active', '', '', '服装', null, '服装', null, null);
INSERT INTO `basedata` VALUES ('900000162', 'CompanyIndustry', 'Active', '', '', '奢饰品', null, '奢饰品', null, null);
INSERT INTO `basedata` VALUES ('900000163', 'CompanyIndustry', 'Active', '', '', 'IT', null, 'IT', null, null);
INSERT INTO `basedata` VALUES ('900000164', 'CompanyIndustry', 'Active', '', '', '珠宝饰品', null, '珠宝饰品', null, null);
INSERT INTO `basedata` VALUES ('900000165', 'CompanyIndustry', 'Active', '', '', '广告企业', null, '广告企业', null, null);
INSERT INTO `basedata` VALUES ('900000166', 'CompanyIndustry', 'Active', '', '', '烟酒类', null, '烟酒类', null, null);
INSERT INTO `basedata` VALUES ('900000167', 'CompanyIndustry', 'Active', '', '', '金融', null, '金融', null, null);
INSERT INTO `basedata` VALUES ('900000168', 'CompanyIndustry', 'Active', '', '', '旅游航空', null, '旅游航空', null, null);
INSERT INTO `basedata` VALUES ('900000169', 'CompanyIndustry', 'Active', '', '', '其他', null, '其他', null, null);
INSERT INTO `basedata` VALUES ('900000170', 'AgentPassword', 'Active', '', '', '代理官口号', null, '代理官口号', null, null);

-- ----------------------------
-- Table structure for eventlog
-- ----------------------------
DROP TABLE IF EXISTS `eventlog`;
CREATE TABLE `eventlog` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `InstanceID` varchar(20) DEFAULT NULL,
  `EventID` varchar(45) DEFAULT NULL,
  `ActionType` varchar(45) DEFAULT NULL,
  `ActionObject` varchar(45) DEFAULT NULL,
  `ActionTime` datetime DEFAULT NULL,
  `Operator` varchar(45) DEFAULT NULL,
  `Remark` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of eventlog
-- ----------------------------

-- ----------------------------
-- Table structure for filesystem
-- ----------------------------
DROP TABLE IF EXISTS `filesystem`;
CREATE TABLE `filesystem` (
  `FileNO` int(10) NOT NULL AUTO_INCREMENT,
  `Fun` varchar(50) DEFAULT NULL,
  `TypeName` varchar(200) DEFAULT NULL,
  `InstanceID` varchar(30) DEFAULT NULL,
  `Path` varchar(500) DEFAULT NULL,
  `Status` varchar(60) DEFAULT NULL,
  `CtreateTime` datetime DEFAULT NULL,
  `OldName` varchar(300) DEFAULT NULL,
  `NewName` varchar(300) DEFAULT NULL,
  `CreateUser` int(200) DEFAULT NULL,
  `BelongNO` int(15) DEFAULT NULL,
  PRIMARY KEY (`FileNO`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of filesystem
-- ----------------------------
INSERT INTO `filesystem` VALUES ('1', 'IDFront', 'Company', 'SP_A_1', 'http://localhost:58486/document/Company/20000000/IDFront20160820202057.jpg', 'Active', '2016-08-20 20:20:58', 'IMG_20160627_183046.jpg', 'IDFront20160820202057.jpg', '20000000', null);
INSERT INTO `filesystem` VALUES ('2', 'IDOpposite', 'Company', 'SP_A_1', 'http://localhost:58486/document/Company/20000000/IDOpposite20160820202057.jpg', 'Active', '2016-08-20 20:20:58', 'IMG_20160625_182302.jpg', 'IDOpposite20160820202057.jpg', '20000000', null);
INSERT INTO `filesystem` VALUES ('3', 'License', 'Company', 'SP_A_1', 'http://localhost:58486/document/Company/20000000/License20160820202128.jpg', 'Active', '2016-08-20 20:21:28', 'IMG_20160627_203507.jpg', 'License20160820202128.jpg', '20000000', null);
INSERT INTO `filesystem` VALUES ('4', 'SponsorBook', 'Company', 'SP_A_1', 'http://localhost:58486/document/Company/20000000/SponsorBook20160820202906.jpg', 'Active', '2016-08-20 20:29:07', 'IMG_20160613_080451.jpg', 'SponsorBook20160820202906.jpg', '20000000', null);
INSERT INTO `filesystem` VALUES ('5', 'SponsorBook', 'Company', 'SP_A_1', 'http://localhost:58486/document/Company/20000000/SponsorBook20160820235325.jpg', 'Active', '2016-08-20 23:53:26', 'IMG_20160613_080438.jpg', 'SponsorBook20160820235325.jpg', '20000000', null);
INSERT INTO `filesystem` VALUES ('6', 'SponsorBook', 'Company', 'SP_A_1', 'http://localhost:58486/document/Company/20000000/SponsorBook20160821001759.jpg', 'Active', '2016-08-21 00:17:59', '15913994_mh1467459197242.jpg', 'SponsorBook20160821001759.jpg', '20000000', null);
INSERT INTO `filesystem` VALUES ('7', 'SponsorBook', 'Project', 'SP_A_1', 'http://localhost:58486/document/Company/20000000/SponsorBook20160824191020.jpg', 'Active', '2016-08-24 19:10:20', 'Chrysanthemum.jpg', 'SponsorBook20160824191020.jpg', '20000000', '30000004');
INSERT INTO `filesystem` VALUES ('8', 'SponsorBook', 'Project', 'SP_A_1', 'http://localhost:58486/document/Company/20000000/SponsorBook20160824231351.jpg', 'Active', '2016-08-24 23:13:52', 'Chrysanthemum.jpg', 'SponsorBook20160824231351.jpg', '20000000', '30000005');
INSERT INTO `filesystem` VALUES ('9', 'SponsorBook', 'Project', 'SP_A_1', 'http://localhost:58486/document/Company/20000000/SponsorBook20160824231825.jpg', 'Active', '2016-08-24 23:18:25', 'Jellyfish.jpg', 'SponsorBook20160824231825.jpg', '20000000', '30000006');
INSERT INTO `filesystem` VALUES ('10', 'SponsorBook', 'Project', 'SP_A_1', 'http://localhost:58486/document/Company/20000000/SponsorBook20160824232124.jpg', 'Active', '2016-08-24 23:21:24', 'Jellyfish.jpg', 'SponsorBook20160824232124.jpg', '20000000', '30000007');
INSERT INTO `filesystem` VALUES ('11', 'SponsorBook', 'Project', 'SP_A_1', 'http://localhost:58486/document/Company/20000000/SponsorBook20160824232242.jpg', 'Active', '2016-08-24 23:22:43', 'Jellyfish.jpg', 'SponsorBook20160824232242.jpg', '20000000', '30000008');

-- ----------------------------
-- Table structure for lifecycleevent
-- ----------------------------
DROP TABLE IF EXISTS `lifecycleevent`;
CREATE TABLE `lifecycleevent` (
  `ID` int(15) NOT NULL AUTO_INCREMENT,
  `RoleType` varchar(100) DEFAULT NULL,
  `RoleNO` int(15) DEFAULT NULL,
  `Fun` varchar(255) DEFAULT NULL,
  `ValueFrom` varchar(255) DEFAULT NULL,
  `ValueTo` varchar(255) DEFAULT NULL,
  `UpdatedTime` datetime DEFAULT NULL,
  `UpdatedUser` int(15) DEFAULT NULL,
  `Remark` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of lifecycleevent
-- ----------------------------

-- ----------------------------
-- Table structure for money
-- ----------------------------
DROP TABLE IF EXISTS `money`;
CREATE TABLE `money` (
  `RoleNO` int(10) DEFAULT NULL,
  `Fun` varchar(30) DEFAULT NULL,
  `CountMoney` double DEFAULT NULL,
  `Balance` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of money
-- ----------------------------

-- ----------------------------
-- Table structure for moneylog
-- ----------------------------
DROP TABLE IF EXISTS `moneylog`;
CREATE TABLE `moneylog` (
  `ID` varchar(40) DEFAULT NULL,
  `Type` varchar(40) DEFAULT NULL,
  `ValueFrom` varchar(100) DEFAULT NULL,
  `ValueTo` varchar(100) DEFAULT NULL,
  `Amount` double DEFAULT NULL,
  `Status` varchar(60) DEFAULT NULL,
  `CreateTime` datetime DEFAULT NULL,
  `UpdateTime` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of moneylog
-- ----------------------------

-- ----------------------------
-- Table structure for project
-- ----------------------------
DROP TABLE IF EXISTS `project`;
CREATE TABLE `project` (
  `ProjectID` int(11) NOT NULL AUTO_INCREMENT,
  `ProjectName` varchar(300) DEFAULT NULL,
  `Address` varchar(300) DEFAULT NULL,
  `Amount` double DEFAULT NULL,
  `StartDate` datetime DEFAULT NULL,
  `EndDate` datetime DEFAULT NULL,
  `Status` varchar(200) DEFAULT NULL,
  `Reamrk` varchar(1000) DEFAULT NULL,
  `CreatorID` int(20) DEFAULT NULL,
  `CreatorType` varchar(200) DEFAULT NULL,
  `CreatorName` varchar(200) DEFAULT NULL,
  `CreateDate` datetime DEFAULT NULL,
  `UpdateDate` datetime DEFAULT NULL,
  `UpdateUser` int(20) DEFAULT NULL,
  PRIMARY KEY (`ProjectID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of project
-- ----------------------------

-- ----------------------------
-- Table structure for projectcontract
-- ----------------------------
DROP TABLE IF EXISTS `projectcontract`;
CREATE TABLE `projectcontract` (
  `ContractID` int(11) NOT NULL,
  `ProjectID` int(11) DEFAULT NULL,
  `AgentID` varchar(100) DEFAULT NULL,
  `ContractCode` varchar(100) DEFAULT NULL,
  `Status` varchar(200) DEFAULT NULL,
  `Amount` double DEFAULT NULL,
  `ContractorID` int(11) DEFAULT NULL,
  `ContractorName` varchar(200) DEFAULT NULL,
  `CreateDate` datetime DEFAULT NULL,
  `SignDate` datetime DEFAULT NULL,
  `UpdateDate` datetime DEFAULT NULL,
  `UpdateUser` int(11) DEFAULT NULL,
  PRIMARY KEY (`ContractID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of projectcontract
-- ----------------------------

-- ----------------------------
-- Table structure for projectdata
-- ----------------------------
DROP TABLE IF EXISTS `projectdata`;
CREATE TABLE `projectdata` (
  `DataID` int(11) NOT NULL AUTO_INCREMENT,
  `ProjectID` int(11) DEFAULT NULL,
  `ContractID` int(11) DEFAULT NULL,
  `DataType` varchar(200) DEFAULT NULL,
  `DataName` varchar(200) DEFAULT NULL,
  `DataValue` varchar(4000) DEFAULT NULL,
  `UpdateDate` datetime DEFAULT NULL,
  `UpdateUser` int(11) DEFAULT NULL,
  PRIMARY KEY (`DataID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of projectdata
-- ----------------------------

-- ----------------------------
-- Table structure for projectsearch
-- ----------------------------
DROP TABLE IF EXISTS `projectsearch`;
CREATE TABLE `projectsearch` (
  `ProjectID` int(11) NOT NULL,
  `KeyWords` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`ProjectID`),
  FULLTEXT KEY `keyword` (`KeyWords`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for relationship
-- ----------------------------
DROP TABLE IF EXISTS `relationship`;
CREATE TABLE `relationship` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `NOFrom` int(15) DEFAULT NULL,
  `Fun` varchar(100) DEFAULT NULL,
  `NOTo` int(15) DEFAULT NULL,
  `NameFrom` varchar(200) DEFAULT NULL,
  `Status` varchar(100) DEFAULT NULL,
  `NameTo` varchar(100) DEFAULT NULL,
  `CreateTime` datetime DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of relationship
-- ----------------------------

-- ----------------------------
-- Table structure for school
-- ----------------------------
DROP TABLE IF EXISTS `school`;
CREATE TABLE `school` (
  `SchoolNO` int(10) NOT NULL AUTO_INCREMENT,
  `SchoolName` varchar(60) DEFAULT NULL,
  `StudentSize` int(11) DEFAULT NULL,
  `ProvinceNO` int(15) DEFAULT NULL,
  `CityNO` int(15) DEFAULT NULL,
  `CountyNO` int(15) DEFAULT NULL,
  `Address` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`SchoolNO`)
) ENGINE=InnoDB AUTO_INCREMENT=500148 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of school
-- ----------------------------
INSERT INTO `school` VALUES ('101', '', null, null, null, null, null);
INSERT INTO `school` VALUES ('500001', '东莞理工学院', null, null, '300009', null, null);
INSERT INTO `school` VALUES ('500002', '广东科技学院', null, null, '300009', null, null);
INSERT INTO `school` VALUES ('500003', '东莞理工学院城市学院', null, null, '300009', null, null);
INSERT INTO `school` VALUES ('500004', '东莞职业技术学院', null, null, '300009', null, null);
INSERT INTO `school` VALUES ('500005', '广东亚视演艺职业学院', null, null, '300009', null, null);
INSERT INTO `school` VALUES ('500006', '广东创新科技职业学院', null, null, '300009', null, null);
INSERT INTO `school` VALUES ('500007', '广东酒店管理职业技术学院', null, null, '300009', null, null);
INSERT INTO `school` VALUES ('500008', '电子科技大学中山学院', null, null, '300014', null, null);
INSERT INTO `school` VALUES ('500009', '中山火炬职业技术学院', null, null, '300014', null, null);
INSERT INTO `school` VALUES ('500010', '中山职业技术学院', null, null, '300014', null, null);
INSERT INTO `school` VALUES ('500011', '罗定职业技术学院', null, null, '300020', null, null);
INSERT INTO `school` VALUES ('500012', '佛山科学技术学院', null, null, '300011', null, null);
INSERT INTO `school` VALUES ('500013', '广东东软学院', null, null, '300011', null, null);
INSERT INTO `school` VALUES ('500014', '广东职业技术学院', null, null, '300011', null, null);
INSERT INTO `school` VALUES ('500015', '广东科贸职业学院', null, null, '300011', null, null);
INSERT INTO `school` VALUES ('500016', '佛山职业技术学院', null, null, '300011', null, null);
INSERT INTO `school` VALUES ('500017', '顺德职业技术学院', null, null, '300011', null, null);
INSERT INTO `school` VALUES ('500018', '中山大学', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500019', '华南理工大学', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500020', '暨南大学', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500021', '华南农业大学', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500022', '南方医科大学', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500023', '广州中医药大学', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500024', '华南师范大学', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500025', '广东工业大学', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500026', '广东外语外贸大学', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500027', '广东财经大学', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500028', '仲恺农业工程学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500029', '广东药科大学', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500030', '星海音乐学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500031', '广州美术学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500032', '广州体育学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500033', '广东技术师范学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500034', '广东金融学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500035', '广东警官学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500036', '广东第二师范学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500037', '广州航海学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500038', '广州大学', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500039', '广州医科大学', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500040', '广东培正学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500041', '广东白云学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500042', '广州商学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500043', '广州工商学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500044', '广东工业大学华立学院 ', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500045', '广州大学松田学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500046', '中山大学新华学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500047', '中山大学南方学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500048', '华南理工大学广州学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500049', '华南农业大学珠江学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500050', '广东外语外贸大学南国商学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500051', '广东财经大学华商学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500052', '广东技术师范学院天河学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500053', '广州大学华软软件学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500054', '广州民航职业技术学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500055', '广东轻工职业技术学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500056', '广东省外语艺术职业学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500057', '广东机电职业技术学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500058', '广东工贸职业技术学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500059', '广东建设职业技术学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500060', '广东理工职业学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500061', '广东科学技术职业学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500062', '广东交通职业技术学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500063', '广东水利电力职业技术学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500064', '广东司法警官职业学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500065', '广东行政职业学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500066', '广东体育职业技术学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500067', '广东文艺职业学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500068', '广东食品药品职业学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500069', '广东女子职业技术学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500070', '广东农工商职业技术学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500071', '广东邮电职业技术学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500072', '广东工程职业技术学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500073', '广东环境保护工程职业学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500074', '广东青年职业学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500075', '广东舞蹈戏剧职业学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500076', '广东生态工程职业学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500077', '广州番禺职业技术学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500078', '广州体育职业技术学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500079', '广州工程技术职业学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500080', '广州铁路职业技术学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500081', '广州城市职业学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500082', '广州科技贸易职业学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500083', '民办南华工商学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500084', '私立华联学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500085', '广东岭南职业技术学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500086', '广州康大职业技术学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500087', '广州涉外经济职业技术学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500088', '广州南洋理工职业学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500089', '广州科技职业技术学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500090', '广州华南商贸职业学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500091', '广州华立科技职业学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500092', '广州现代信息工程职业技术学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500093', '广州珠江职业技术学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500094', '广州松田职业学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500095', '广州城建职业学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500096', '广州华商职业学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500097', '广州华夏职业学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500098', '广州东华职业学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500099', '公安边防部队高等专科学校', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500100', '广州卫生职业技术学院', null, null, '300000', null, null);
INSERT INTO `school` VALUES ('500101', '惠州学院', null, null, '300008', null, null);
INSERT INTO `school` VALUES ('500102', '惠州卫生职业技术学院', null, null, '300008', null, null);
INSERT INTO `school` VALUES ('500103', '惠州城市职业学院', null, null, '300008', null, null);
INSERT INTO `school` VALUES ('500104', '惠州经济职业技术学院', null, null, '300008', null, null);
INSERT INTO `school` VALUES ('500105', '揭阳职业技术学院', null, null, '300019', null, null);
INSERT INTO `school` VALUES ('500106', '潮汕职业技术学院', null, null, '300019', null, null);
INSERT INTO `school` VALUES ('500107', '嘉应学院', null, null, '300007', null, null);
INSERT INTO `school` VALUES ('500108', '汕头大学', null, null, '300001', null, null);
INSERT INTO `school` VALUES ('500109', '汕头职业技术学院', null, null, '300001', null, null);
INSERT INTO `school` VALUES ('500110', '汕尾职业技术学院', null, null, '300016', null, null);
INSERT INTO `school` VALUES ('500111', '五邑大学', null, null, '300010', null, null);
INSERT INTO `school` VALUES ('500112', '江门职业技术学院', null, null, '300010', null, null);
INSERT INTO `school` VALUES ('500113', '广东南方职业学院', null, null, '300010', null, null);
INSERT INTO `school` VALUES ('500114', '河源职业技术学院', null, null, '300015', null, null);
INSERT INTO `school` VALUES ('500115', '深圳大学', null, null, '300005', null, null);
INSERT INTO `school` VALUES ('500116', '南方科技大学', null, null, '300005', null, null);
INSERT INTO `school` VALUES ('500117', '香港中文大学（深圳）', null, null, '300005', null, null);
INSERT INTO `school` VALUES ('500118', '深圳职业技术学院', null, null, '300005', null, null);
INSERT INTO `school` VALUES ('500119', '深圳信息职业技术学院', null, null, '300005', null, null);
INSERT INTO `school` VALUES ('500120', '广东新安职业技术学院', null, null, '300005', null, null);
INSERT INTO `school` VALUES ('500121', '清远职业技术学院', null, null, '300018', null, null);
INSERT INTO `school` VALUES ('500122', '广东碧桂园职业学院', null, null, '300018', null, null);
INSERT INTO `school` VALUES ('500123', '广东医科大学', null, null, '300002', null, null);
INSERT INTO `school` VALUES ('500124', '广东海洋大学', null, null, '300002', null, null);
INSERT INTO `school` VALUES ('500125', '岭南师范学院', null, null, '300002', null, null);
INSERT INTO `school` VALUES ('500126', '广东海洋大学寸金学院', null, null, '300002', null, null);
INSERT INTO `school` VALUES ('500127', '广东文理职业学院', null, null, '300002', null, null);
INSERT INTO `school` VALUES ('500128', '湛江幼儿师范专科学校', null, null, '300002', null, null);
INSERT INTO `school` VALUES ('500129', '韩山师范学院', null, null, '300003', null, null);
INSERT INTO `school` VALUES ('500130', '北京师范大学－香港浸会大学联合国际学院', null, null, '300013', null, null);
INSERT INTO `school` VALUES ('500131', '北京师范大学珠海分校', null, null, '300013', null, null);
INSERT INTO `school` VALUES ('500132', '北京理工大学珠海学院', null, null, '300013', null, null);
INSERT INTO `school` VALUES ('500133', '吉林大学珠海学院', null, null, '300013', null, null);
INSERT INTO `school` VALUES ('500134', '珠海城市职业技术学院', null, null, '300013', null, null);
INSERT INTO `school` VALUES ('500135', '珠海艺术职业学院', null, null, '300013', null, null);
INSERT INTO `school` VALUES ('500136', '肇庆学院', null, null, '300012', null, null);
INSERT INTO `school` VALUES ('500137', '广东理工学院', null, null, '300012', null, null);
INSERT INTO `school` VALUES ('500138', '肇庆医学高等专科学校', null, null, '300012', null, null);
INSERT INTO `school` VALUES ('500139', '广东工商职业学院', null, null, '300012', null, null);
INSERT INTO `school` VALUES ('500140', '广东信息工程职业学院', null, null, '300012', null, null);
INSERT INTO `school` VALUES ('500141', '广东石油化工学院', null, null, '300004', null, null);
INSERT INTO `school` VALUES ('500142', '茂名职业技术学院', null, null, '300004', null, null);
INSERT INTO `school` VALUES ('500143', '广东茂名健康职业学院', null, null, '300004', null, null);
INSERT INTO `school` VALUES ('500144', '广东茂名幼儿师范专科学校', null, null, '300004', null, null);
INSERT INTO `school` VALUES ('500145', '阳江职业技术学院', null, null, '300017', null, null);
INSERT INTO `school` VALUES ('500146', '韶关学院', null, null, '300006', null, null);
INSERT INTO `school` VALUES ('500147', '广东松山职业技术学院', null, null, '300006', null, null);

-- ----------------------------
-- Table structure for seldomused
-- ----------------------------
DROP TABLE IF EXISTS `seldomused`;
CREATE TABLE `seldomused` (
  `ID` int(12) NOT NULL AUTO_INCREMENT,
  `BelongNo` int(20) DEFAULT NULL,
  `BelongType` varchar(100) DEFAULT NULL,
  `Type` varchar(100) DEFAULT NULL,
  `Value` varchar(500) DEFAULT NULL,
  `Status` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of seldomused
-- ----------------------------

-- ----------------------------
-- Table structure for spliteword
-- ----------------------------
DROP TABLE IF EXISTS `spliteword`;
CREATE TABLE `spliteword` (
  `ID` int(15) NOT NULL,
  `Fun` varchar(100) DEFAULT NULL,
  `Value` varchar(500) DEFAULT NULL,
  `SpliteValue` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of spliteword
-- ----------------------------

-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
  `StudentNO` int(10) NOT NULL,
  `Name` varchar(100) DEFAULT NULL,
  `StudentLDNO` varchar(16) DEFAULT NULL,
  `StudentGrade` varchar(10) DEFAULT NULL,
  `Status` varchar(60) DEFAULT NULL,
  `Remark` varchar(255) DEFAULT NULL,
  `Education` varchar(50) DEFAULT NULL,
  `SchoolNO` int(15) DEFAULT NULL,
  `Major` varchar(100) DEFAULT NULL,
  `EntranceDate` datetime DEFAULT NULL,
  `UpdateTime` datetime DEFAULT NULL,
  `CreateTime` datetime DEFAULT NULL,

  PRIMARY KEY (`StudentNO`),
  KEY `FKStudent321838` (`StudentNO`),
  CONSTRAINT `FKStudent321838` FOREIGN KEY (`StudentNO`) REFERENCES `userinfo` (`UserNo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of student
-- ----------------------------

-- ----------------------------
-- Table structure for userinfo
-- ----------------------------
DROP TABLE IF EXISTS `userinfo`;
CREATE TABLE `userinfo` (
  `UserNo` int(10) NOT NULL AUTO_INCREMENT,
  `UserName` varchar(60) DEFAULT NULL,
  `NickName` varchar(60) DEFAULT NULL,
  `Password` varchar(180) NOT NULL,
  `Phone` varchar(18) DEFAULT NULL,
  `QQ` varchar(20) DEFAULT NULL,
  `WeChart` varchar(30) DEFAULT NULL,
  `Role` varchar(30) DEFAULT NULL,
  `UserType` varchar(15) DEFAULT NULL,
  `Email` varchar(100) DEFAULT NULL,
  `Sex` varchar(8) DEFAULT NULL,
  `Status` varchar(60) DEFAULT NULL,
  `CreateTime` datetime(6) DEFAULT NULL,
  `UpdateTime` datetime(6) DEFAULT NULL,
  `AgentPassword` varchar(100) DEFAULT NULL,
  `HeadImage` varchar(300) DEFAULT NULL,
  PRIMARY KEY (`UserNo`)
) ENGINE=InnoDB AUTO_INCREMENT=10000028 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of userinfo
-- ----------------------------

-- ----------------------------
-- Table structure for validation
-- ----------------------------
DROP TABLE IF EXISTS `validation`;
CREATE TABLE `validation` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `Fun` varchar(60) DEFAULT NULL,
  `ValidateNO` int(60) DEFAULT NULL,
  `ValidateName` varchar(60) DEFAULT NULL,
  `ValidStatus` varchar(20) DEFAULT NULL,
  `ValueFrom` varchar(100) DEFAULT NULL,
  `ValueTo` varchar(100) DEFAULT NULL,
  `CreatedTime` datetime DEFAULT NULL,
  `UpdatedTime` datetime DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of validation
-- ----------------------------
